<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="generator" content="ApiGen 2.8.0" />

	<title>Class bdd_sql | pwe-project</title>

	<script type="text/javascript" src="resources/combined.js?682347548"></script>
	<script type="text/javascript" src="elementlist.js?1761807718"></script>
	<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?3505392360" />

</head>

<body>
<div id="left">
	<div id="menu">
		<a href="index.html" title="Overview"><span>Overview</span></a>


		<div id="groups">
			<h3>Packages</h3>
			<ul>
				<li><a href="package-API.html">API</a>
						</li>
				<li><a href="package-None.html">None</a>
						</li>
				<li><a href="package-PHP.html">PHP</a>
						</li>
				<li class="active"><a href="package-PWE.html">PWE<span></span></a>
						<ul>
				<li class="active"><a href="package-PWE.bdd.html">bdd</a>
						</li>
				<li><a href="package-PWE.controler.html">controler</a>
						</li>
				<li><a href="package-PWE.modele.html">modele<span></span></a>
						<ul>
				<li><a href="package-PWE.modele.menu.html">menu</a>
						</li>
							</ul></li>
				<li><a href="package-PWE.tools.html">tools</a>
						</li>
							</ul></li>
			</ul>
		</div>

		<hr />


		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li class="active"><a href="class-bdd_sql.html">bdd_sql</a></li>
			</ul>





		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form id="search">
		<input type="hidden" name="cx" value="" />
		<input type="hidden" name="ie" value="UTF-8" />
		<input type="text" name="q" class="text" />
		<input type="submit" value="Search" />
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
				<a href="package-PWE.bdd.html" title="Summary of PWE\bdd"><span>Package</span></a>
			</li>
			<li class="active">
<span>Class</span>			</li>
		</ul>
		<ul>
			<li>
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
			</li>
			<li>
				<a href="deprecated.html" title="List of deprecated elements"><span>Deprecated</span></a>
			</li>
			<li>
				<a href="todo.html" title="Todo list"><span>Todo</span></a>
			</li>
		</ul>
		<ul>
			<li>
				<a href="pwe-project-api-documentation.zip" title="Download documentation as ZIP archive"><span>Download</span></a>
			</li>
		</ul>
	</div>

<div id="content" class="class">
	<h1>Class bdd_sql</h1>











	<div class="info">
		
		
		
		<b>Package:</b> <a href="package-PWE.html">PWE</a>\<a href="package-PWE.bdd.html">bdd</a><br />

				<b>Author:</b>
				Gmax &lt;<a
href="mailto:gmaxfr78&#64;gmail.com">gmaxfr78&#64;<!---->gmail.com</a>&gt;<br />
		<b>Located at</b> <a href="source-class-bdd_sql.html#2-259" title="Go to source code">engine/class/bdd/sql.class.php</a><br />
	</div>



	<table class="summary" id="methods">
	<caption>Methods summary</caption>
	<tr data-order="setServer" id="_setServer">

		<td class="attributes"><code>
			 public static
			
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_setServer">#</a>
		<code><a href="source-class-bdd_sql.html#17-27" title="Go to source code">setServer</a>( <span>mixed <var>$conf</var></span> )</code>

		<div class="description short">
			
		</div>

		<div class="description detailed hidden">
			







		</div>
		</div></td>
	</tr>
	<tr data-order="open" id="_open">

		<td class="attributes"><code>
			 public static
			array
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_open">#</a>
		<code><a href="source-class-bdd_sql.html#29-56" title="Go to source code">open</a>( )</code>

		<div class="description short">
			
<p>retourne le resultat de la requete sql dans un tableau 'count' nombre de
ligne retournées 'results' $fetch==true =&gt; tableau des resultats
'fetcher'<br />
$fetch==false =&gt; resultat brut</p>

		</div>

		<div class="description detailed hidden">
			
<p>retourne le resultat de la requete sql dans un tableau 'count' nombre de
ligne retournées 'results' $fetch==true =&gt; tableau des resultats 'fetcher'
$fetch==false =&gt; resultat brut</p>




				<h4>Returns</h4>
				<div class="list">
					<code>array</code><br />
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="open_pdo" id="_open_pdo">

		<td class="attributes"><code>
			 public static
			
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_open_pdo">#</a>
		<code><a href="source-class-bdd_sql.html#57-68" title="Go to source code">open_pdo</a>( )</code>

		<div class="description short">
			
		</div>

		<div class="description detailed hidden">
			







		</div>
		</div></td>
	</tr>
	<tr data-order="testConnexion" id="_testConnexion">

		<td class="attributes"><code>
			 public static
			array
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_testConnexion">#</a>
		<code><a href="source-class-bdd_sql.html#70-116" title="Go to source code">testConnexion</a>( <span>string <var>$server</var></span>, <span>string <var>$user</var></span>, <span>string <var>$password</var></span>, <span>mixed <var>$dbname</var></span> )</code>

		<div class="description short">
			
<p>test la connectibilité au serveur, renvoi un tableau
[success(boolean),error(string),connect(PDO|int),pdo(boolean)]</p>

		</div>

		<div class="description detailed hidden">
			
<p>test la connectibilité au serveur, renvoi un tableau
[success(boolean),error(string),connect(PDO|int),pdo(boolean)]</p>



				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$server</var></dt>
					<dd><code>string</code><br>$server</dd>
					<dt><var>$user</var></dt>
					<dd><code>string</code><br>$user</dd>
					<dt><var>$password</var></dt>
					<dd><code>string</code><br>$password</dd>
					<dt><var>$dbname</var></dt>
					<dd></dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					<code>array</code><br />
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="installDataBase" id="_installDataBase">

		<td class="attributes"><code>
			 public static
			array
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_installDataBase">#</a>
		<code><a href="source-class-bdd_sql.html#117-151" title="Go to source code">installDataBase</a>( <span>string <var>$server</var></span>, <span>string <var>$user</var></span>, <span>string <var>$password</var></span>, <span>string <var>$dbname</var></span>, <span>string <var>$tableConfig</var></span> )</code>

		<div class="description short">
			
<p>installation de la base de données via sql $tableConfig</p>

		</div>

		<div class="description detailed hidden">
			
<p>installation de la base de données via sql $tableConfig</p>



				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$server</var></dt>
					<dd><code>string</code><br>$server</dd>
					<dt><var>$user</var></dt>
					<dd><code>string</code><br>$user</dd>
					<dt><var>$password</var></dt>
					<dd><code>string</code><br>$password</dd>
					<dt><var>$dbname</var></dt>
					<dd><code>string</code><br>$dbname</dd>
					<dt><var>$tableConfig</var></dt>
					<dd><code>string</code><br>$tableConfig</dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					<code>array</code><br />
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="close" id="_close">

		<td class="attributes"><code>
			 public static
			
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_close">#</a>
		<code><a href="source-class-bdd_sql.html#152-163" title="Go to source code">close</a>( )</code>

		<div class="description short">
			
<p>fermeture de la connexion sql</p>

		</div>

		<div class="description detailed hidden">
			
<p>fermeture de la connexion sql</p>








		</div>
		</div></td>
	</tr>
	<tr data-order="doSql" id="_doSql">

		<td class="attributes"><code>
			 public static
			array
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_doSql">#</a>
		<code><a href="source-class-bdd_sql.html#165-203" title="Go to source code">doSql</a>( <span>string <var>$sql</var></span>, <span>boolean <var>$fetch</var> = <span class="php-keyword1">true</span></span>, <span>boolean <var>$assoc</var> = <span class="php-keyword1">false</span></span> )</code>

		<div class="description short">
			
<p>renvoi le tableau de résultat pour la requête $sql</p>

		</div>

		<div class="description detailed hidden">
			
<p>renvoi le tableau de résultat pour la requête $sql</p>



				<h4>Parameters</h4>
				<div class="list"><dl>
					<dt><var>$sql</var></dt>
					<dd><code>string</code><br>$sql : query sql à executer</dd>
					<dt><var>$fetch</var></dt>
					<dd><code>boolean</code><br>$fetch : true pour renvoyer les lignes de résultat en tableau</dd>
					<dt><var>$assoc</var></dt>
					<dd><code>boolean</code><br>$assoc : true pour retourner les lignes en tableau associatif uniquement</dd>
				</dl></div>

				<h4>Returns</h4>
				<div class="list">
					<code>array</code><br>: [count: nombre de ligne de resultat, results: array des lignes de
résultat|résultat brut]<br />
				</div>




		</div>
		</div></td>
	</tr>
	<tr data-order="doSql_pdo" id="_doSql_pdo">

		<td class="attributes"><code>
			 public static
			
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_doSql_pdo">#</a>
		<code><a href="source-class-bdd_sql.html#204-224" title="Go to source code">doSql_pdo</a>( <span>mixed <var>$sql</var></span>, <span>mixed <var>$fetch</var> = <span class="php-keyword1">true</span></span>, <span>mixed <var>$assoc</var> = <span class="php-keyword1">false</span></span> )</code>

		<div class="description short">
			
		</div>

		<div class="description detailed hidden">
			







		</div>
		</div></td>
	</tr>
	<tr data-order="changePrefixTable" id="_changePrefixTable">

		<td class="attributes"><code>
			 public static
			
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_changePrefixTable">#</a>
		<code><a href="source-class-bdd_sql.html#226-246" title="Go to source code">changePrefixTable</a>( <span>mixed <var>$newPrefix</var></span>, <span>mixed <var>$oldPrefix</var> = <span class="php-quote">''</span></span> )</code>

		<div class="description short">
			
		</div>

		<div class="description detailed hidden">
			







		</div>
		</div></td>
	</tr>
	<tr data-order="getLastInsertId" id="_getLastInsertId">

		<td class="attributes"><code>
			 public static
			integer
			
			</code>
		</td>

		<td class="name"><div>
		<a class="anchor" href="#_getLastInsertId">#</a>
		<code><a href="source-class-bdd_sql.html#248-258" title="Go to source code">getLastInsertId</a>( )</code>

		<div class="description short">
			
<p>retourne la valeur du dernier identifiant autoincrémenté</p>

		</div>

		<div class="description detailed hidden">
			
<p>retourne la valeur du dernier identifiant autoincrémenté</p>




				<h4>Returns</h4>
				<div class="list">
					<code>integer</code><br />
				</div>




		</div>
		</div></td>
	</tr>
	</table>












	<table class="summary" id="properties">
	<caption>Properties summary</caption>
	<tr data-order="CONNECTION" id="$CONNECTION">
		<td class="attributes"><code>
			public static 
			mixed
		</code></td>

		<td class="name">
				<a href="source-class-bdd_sql.html#7" title="Go to source code"><var>$CONNECTION</var></a>
		</td>
		<td class="value"><code><span class="php-keyword1">null</span></code></td>
		<td class="description"><div>
			<a href="#$CONNECTION" class="anchor">#</a>

			<div class="description short">
				
			</div>

			<div class="description detailed hidden">
				

			</div>
		</div></td>
	</tr>
	<tr data-order="LASTERROR" id="$LASTERROR">
		<td class="attributes"><code>
			public static 
			mixed
		</code></td>

		<td class="name">
				<a href="source-class-bdd_sql.html#8" title="Go to source code"><var>$LASTERROR</var></a>
		</td>
		<td class="value"><code></code></td>
		<td class="description"><div>
			<a href="#$LASTERROR" class="anchor">#</a>

			<div class="description short">
				
			</div>

			<div class="description detailed hidden">
				

			</div>
		</div></td>
	</tr>
	<tr data-order="_PDO_MODE" id="$_PDO_MODE">
		<td class="attributes"><code>
			private static 
			boolean
		</code></td>

		<td class="name">
				<a href="source-class-bdd_sql.html#10" title="Go to source code"><var>$_PDO_MODE</var></a>
		</td>
		<td class="value"><code><span class="php-keyword1">true</span></code></td>
		<td class="description"><div>
			<a href="#$_PDO_MODE" class="anchor">#</a>

			<div class="description short">
				
			</div>

			<div class="description detailed hidden">
				

			</div>
		</div></td>
	</tr>
	<tr data-order="_serveur" id="$_serveur">
		<td class="attributes"><code>
			private static 
			mixed
		</code></td>

		<td class="name">
				<a href="source-class-bdd_sql.html#12" title="Go to source code"><var>$_serveur</var></a>
		</td>
		<td class="value"><code></code></td>
		<td class="description"><div>
			<a href="#$_serveur" class="anchor">#</a>

			<div class="description short">
				
			</div>

			<div class="description detailed hidden">
				

			</div>
		</div></td>
	</tr>
	<tr data-order="_dbname" id="$_dbname">
		<td class="attributes"><code>
			private static 
			mixed
		</code></td>

		<td class="name">
				<a href="source-class-bdd_sql.html#13" title="Go to source code"><var>$_dbname</var></a>
		</td>
		<td class="value"><code></code></td>
		<td class="description"><div>
			<a href="#$_dbname" class="anchor">#</a>

			<div class="description short">
				
			</div>

			<div class="description detailed hidden">
				

			</div>
		</div></td>
	</tr>
	<tr data-order="_username" id="$_username">
		<td class="attributes"><code>
			private static 
			mixed
		</code></td>

		<td class="name">
				<a href="source-class-bdd_sql.html#14" title="Go to source code"><var>$_username</var></a>
		</td>
		<td class="value"><code></code></td>
		<td class="description"><div>
			<a href="#$_username" class="anchor">#</a>

			<div class="description short">
				
			</div>

			<div class="description detailed hidden">
				

			</div>
		</div></td>
	</tr>
	<tr data-order="_password" id="$_password">
		<td class="attributes"><code>
			private static 
			mixed
		</code></td>

		<td class="name">
				<a href="source-class-bdd_sql.html#15" title="Go to source code"><var>$_password</var></a>
		</td>
		<td class="value"><code></code></td>
		<td class="description"><div>
			<a href="#$_password" class="anchor">#</a>

			<div class="description short">
				
			</div>

			<div class="description detailed hidden">
				

			</div>
		</div></td>
	</tr>
	</table>






</div>

	<div id="footer">
		pwe-project API documentation generated by <a href="http://apigen.org">ApiGen 2.8.0</a>
	</div>
</div>
</div>
</body>
</html>
